home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Nebula 1
/
Nebula One.iso
/
Misc
/
msql-1.0.6
/
src
/
tests
/
rtest.src
/
5.out
< prev
next >
Wrap
Text File
|
1995-01-04
|
2KB
|
83 lines
Welcome to the miniSQL monitor. Type \h for help.
mSQL > ->
Query buffer
------------
select phone from test where user = 'Bambi'
[continue]
->
Query OK.
1 rows matched.
+----------------------+
| phone |
+----------------------+
| (075) 951450 |
+----------------------+
mSQL > ->
Query buffer
------------
select * from test2
[continue]
->
Query OK.
3 rows matched.
+------------+--------------------------------+
| user | fullname |
+------------+--------------------------------+
| paulp | Paul Pyyvaara |
| Bambi | David J. Hughes |
| fred | Fred O'Niell |
+------------+--------------------------------+
mSQL > ->
Query buffer
------------
select * from test where phone = '(075) 951412'
[continue]
->
Query OK.
1 rows matched.
+------------+----------+----------------------+
| user | age | phone |
+------------+----------+----------------------+
| paulp | 25 | (075) 951412 |
+------------+----------+----------------------+
mSQL > ->
Query buffer
------------
select * from test where user like '%am%'
[continue]
->
Query OK.
1 rows matched.
+------------+----------+----------------------+
| user | age | phone |
+------------+----------+----------------------+
| Bambi | 26 | (075) 951450 |
+------------+----------+----------------------+
mSQL >
Bye!